MySQL, replacing with... nothing (delete those, please!)
Posted
by
javipas
on Server Fault
See other posts from Server Fault
or by javipas
Published on 2011-03-13T00:52:57Z
Indexed on
2011/03/13
8:11 UTC
Read the original article
Hit count: 613
I'm trying to purge my WordPress content from "false" carriage return (CR). These are caused after a migration of my content, that now presents from time to time a code that makes the web rendering engine to "paint" a CR where I would like to be nothing. The paragraphs seem to have a double CR because of this, and look too far apart.
I'd like to be able to make a MySQL query in order to get rid of that strings, but at the moment I haven't found the key. What I've tried is
UPDATE wp_posts set post_content = replace (post_content,' ',' ');
But i get
<p> </p>
where before were the strings. This seems not the answer at all. Could it have to be with the ampersand, and in that case, should I use something like &nbsp; or something similar?
© Server Fault or respective owner
